Airbnb Booking

Dataset statistics

Number of variables	21
Number of observations	1437720
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	72007
Duplicate rows (%)	5.0%
Total size in memory	230.3 MiB
Average record size in memory	168.0 B

Variable types

Numeric	14
Categorical	7

Alerts

Dataset has 72007 (5.0%) duplicate rows	Duplicates
`year_first_active` is highly overall correlated with `year_first_booking` and 1 other fields	High correlation
`month_first_active` is highly overall correlated with `week_of_year_first_active` and 4 other fields	High correlation
`day_first_active` is highly overall correlated with `day_account_created`	High correlation
`week_of_year_first_active` is highly overall correlated with `month_first_active` and 4 other fields	High correlation
`year_first_booking` is highly overall correlated with `year_first_active` and 1 other fields	High correlation
`month_first_booking` is highly overall correlated with `month_first_active` and 4 other fields	High correlation
`week_of_year_first_booking` is highly overall correlated with `month_first_active` and 4 other fields	High correlation
`month_account_created` is highly overall correlated with `month_first_active` and 4 other fields	High correlation
`day_account_created` is highly overall correlated with `day_first_active`	High correlation
`week_of_year_account_created` is highly overall correlated with `month_first_active` and 4 other fields	High correlation
`year_account_created` is highly overall correlated with `year_first_active` and 1 other fields	High correlation
`language` is highly imbalanced (94.3%)	Imbalance
`days_from_first_active_until_account_created` is highly skewed (γ1 = 58.23880372)	Skewed
`country_destination` is uniformly distributed	Uniform
`days_from_first_active_until_account_created` has 1435762 (99.9%) zeros	Zeros
`day_of_week_first_booking` has 317201 (22.1%) zeros	Zeros

Reproduction

Analysis started	2023-01-14 19:00:03.414969
Analysis finished	2023-01-14 19:02:15.777725
Duration	2 minutes and 12.36 seconds
Software version	pandas-profiling vv3.6.2
Download configuration	config.json

age
Real number (ℝ)

Distinct	99
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.331894

Minimum	16
Maximum	115
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.0 MiB

Quantile statistics

Minimum	16
5-th percentile	23
Q1	30
median	37
Q3	38
95-th percentile	60
Maximum	115
Range	99
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	12.130432
Coefficient of variation (CV)	0.32493481
Kurtosis	9.1501361
Mean	37.331894
Median Absolute Deviation (MAD)	5
Skewness	2.3533641
Sum	53672811
Variance	147.14738
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37	398438	27.7%
30	55817	3.9%
31	53308	3.7%
32	52678	3.7%
29	51904	3.6%
28	46777	3.3%
34	45285	3.1%
33	45151	3.1%
27	43605	3.0%
35	39481	2.7%
Other values (89)	605276	42.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16	28	< 0.1%
17	123	< 0.1%
18	7157	0.5%
19	13457	0.9%
20	3045	0.2%
21	11211	0.8%
22	17353	1.2%
23	22248	1.5%
24	28938	2.0%
25	37435	2.6%

Value	Count	Frequency (%)
115	14	< 0.1%
113	5	< 0.1%
112	1	< 0.1%
111	3	< 0.1%
110	739	0.1%
109	44	< 0.1%
108	15	< 0.1%
107	31	< 0.1%
106	44	< 0.1%
105	12345	0.9%

days_from_first_active_until_account_created
Real number (ℝ)

SKEWED ZEROS

Distinct	142
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.28252024

Minimum	0
Maximum	1456
Zeros	1435762
Zeros (%)	99.9%
Negative	0
Negative (%)	0.0%
Memory size	11.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1456
Range	1456
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12.238842
Coefficient of variation (CV)	43.32023
Kurtosis	3984.8331
Mean	0.28252024
Median Absolute Deviation (MAD)	0
Skewness	58.238804
Sum	406185
Variance	149.78925
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1435762	99.9%
5	213	< 0.1%
78	211	< 0.1%
634	113	< 0.1%
516	111	< 0.1%
1	110	< 0.1%
274	99	< 0.1%
237	86	< 0.1%
3	86	< 0.1%
40	62	< 0.1%
Other values (132)	867	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1435762	99.9%
1	110	< 0.1%
2	14	< 0.1%
3	86	< 0.1%
4	5	< 0.1%
5	213	< 0.1%
6	61	< 0.1%
7	20	< 0.1%
9	3	< 0.1%
10	15	< 0.1%

Value	Count	Frequency (%)
1456	1	< 0.1%
1369	3	< 0.1%
1361	1	< 0.1%
1148	1	< 0.1%
1036	2	< 0.1%
1018	1	< 0.1%
1011	55	< 0.1%
998	1	< 0.1%
995	1	< 0.1%
882	5	< 0.1%

year_first_active
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2012.9547

Minimum	2009
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.0 MiB

Quantile statistics

Minimum	2009
5-th percentile	2011
Q1	2012
median	2013
Q3	2014
95-th percentile	2014
Maximum	2014
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.95579958
Coefficient of variation (CV)	0.00047482418
Kurtosis	-0.029339636
Mean	2012.9547
Median Absolute Deviation (MAD)	1
Skewness	-0.70976666
Sum	2.8940653 × 10⁹
Variance	0.91355283
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2013	554217	38.5%
2014	475585	33.1%
2012	292472	20.3%
2011	98168	6.8%
2010	17257	1.2%
2009	21	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2009	21	< 0.1%
2010	17257	1.2%
2011	98168	6.8%
2012	292472	20.3%
2013	554217	38.5%
2014	475585	33.1%

Value	Count	Frequency (%)
2014	475585	33.1%
2013	554217	38.5%
2012	292472	20.3%
2011	98168	6.8%
2010	17257	1.2%
2009	21	< 0.1%

month_first_active
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.9472401

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	6
Q3	8
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.1113644
Coefficient of variation (CV)	0.52316106
Kurtosis	-0.8612958
Mean	5.9472401
Median Absolute Deviation (MAD)	2
Skewness	0.28400373
Sum	8550466
Variance	9.6805885
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	198716	13.8%
6	191474	13.3%
4	153337	10.7%
3	138108	9.6%
2	110136	7.7%
8	107534	7.5%
9	105078	7.3%
1	104123	7.2%
7	90799	6.3%
10	82198	5.7%
Other values (2)	156217	10.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	104123	7.2%
2	110136	7.7%
3	138108	9.6%
4	153337	10.7%
5	198716	13.8%
6	191474	13.3%
7	90799	6.3%
8	107534	7.5%
9	105078	7.3%
10	82198	5.7%

Value	Count	Frequency (%)
12	74041	5.1%
11	82176	5.7%
10	82198	5.7%
9	105078	7.3%
8	107534	7.5%
7	90799	6.3%
6	191474	13.3%
5	198716	13.8%
4	153337	10.7%
3	138108	9.6%

day_first_active
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.85175

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.0 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7522146
Coefficient of variation (CV)	0.55212924
Kurtosis	-1.1972518
Mean	15.85175
Median Absolute Deviation (MAD)	8
Skewness	-0.001219868
Sum	22790378
Variance	76.601261
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
28	52344	3.6%
3	52043	3.6%
13	50837	3.5%
17	50529	3.5%
24	50104	3.5%
5	49737	3.5%
16	49590	3.4%
10	48981	3.4%
7	48409	3.4%
21	48318	3.4%
Other values (21)	936828	65.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	39336	2.7%
2	43485	3.0%
3	52043	3.6%
4	43948	3.1%
5	49737	3.5%
6	46141	3.2%
7	48409	3.4%
8	48114	3.3%
9	47372	3.3%
10	48981	3.4%

Value	Count	Frequency (%)
31	24672	1.7%
30	47956	3.3%
29	41448	2.9%
28	52344	3.6%
27	45658	3.2%
26	46772	3.3%
25	47655	3.3%
24	50104	3.5%
23	48053	3.3%
22	47286	3.3%

week_of_year_first_active
Real number (ℝ)

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.087601

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.0 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	14
median	23
Q3	34
95-th percentile	48
Maximum	53
Range	52
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	13.474984
Coefficient of variation (CV)	0.55941579
Kurtosis	-0.85159792
Mean	24.087601
Median Absolute Deviation (MAD)	10
Skewness	0.2879042
Sum	34631225
Variance	181.5752
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19	47852	3.3%
26	47062	3.3%
23	46920	3.3%
21	44769	3.1%
22	43371	3.0%
20	43172	3.0%
25	43055	3.0%
24	42323	2.9%
18	42106	2.9%
17	37707	2.6%
Other values (43)	999383	69.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	20432	1.4%
2	18098	1.3%
3	25373	1.8%
4	27393	1.9%
5	24696	1.7%
6	26162	1.8%
7	26461	1.8%
8	30085	2.1%
9	31067	2.2%
10	29845	2.1%

Value	Count	Frequency (%)
53	8	< 0.1%
52	16147	1.1%
51	15922	1.1%
50	16975	1.2%
49	17955	1.2%
48	17198	1.2%
47	19008	1.3%
46	20443	1.4%
45	19279	1.3%
44	18217	1.3%

year_first_booking
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2013.2113

Minimum	2010
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.0 MiB

Quantile statistics

Minimum	2010
5-th percentile	2011
Q1	2013
median	2013
Q3	2014
95-th percentile	2015
Maximum	2015
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.0798515
Coefficient of variation (CV)	0.00053638258
Kurtosis	-0.13289893
Mean	2013.2113
Median Absolute Deviation (MAD)	1
Skewness	-0.4130753
Sum	2.8944341 × 10⁹
Variance	1.1660792
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2014	476121	33.1%
2013	474021	33.0%
2012	252598	17.6%
2015	141152	9.8%
2011	79421	5.5%
2010	14407	1.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2010	14407	1.0%
2011	79421	5.5%
2012	252598	17.6%
2013	474021	33.0%
2014	476121	33.1%
2015	141152	9.8%

Value	Count	Frequency (%)
2015	141152	9.8%
2014	476121	33.1%
2013	474021	33.0%
2012	252598	17.6%
2011	79421	5.5%
2010	14407	1.0%

month_first_booking
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.0412549

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	6
Q3	8
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.8998032
Coefficient of variation (CV)	0.48000015
Kurtosis	-0.63677055
Mean	6.0412549
Median Absolute Deviation (MAD)	2
Skewness	0.24521177
Sum	8685633
Variance	8.4088588
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	295664	20.6%
5	180036	12.5%
4	134076	9.3%
3	121326	8.4%
7	108152	7.5%
8	107974	7.5%
2	98857	6.9%
9	98175	6.8%
10	81496	5.7%
1	79892	5.6%
Other values (2)	132072	9.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	79892	5.6%
2	98857	6.9%
3	121326	8.4%
4	134076	9.3%
5	180036	12.5%
6	295664	20.6%
7	108152	7.5%
8	107974	7.5%
9	98175	6.8%
10	81496	5.7%

Value	Count	Frequency (%)
12	61398	4.3%
11	70674	4.9%
10	81496	5.7%
9	98175	6.8%
8	107974	7.5%
7	108152	7.5%
6	295664	20.6%
5	180036	12.5%
4	134076	9.3%
3	121326	8.4%

day_first_booking
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.753026

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.0 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	9
median	17
Q3	25
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	9.1435575
Coefficient of variation (CV)	0.54578542
Kurtosis	-1.2772498
Mean	16.753026
Median Absolute Deviation (MAD)	8
Skewness	-0.094355362
Sum	24086161
Variance	83.604644
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
29	158226	11.0%
17	47259	3.3%
5	47042	3.3%
21	46657	3.2%
25	46571	3.2%
15	46527	3.2%
3	45785	3.2%
11	44880	3.1%
10	44645	3.1%
23	44504	3.1%
Other values (21)	865624	60.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	43350	3.0%
2	39891	2.8%
3	45785	3.2%
4	41598	2.9%
5	47042	3.3%
6	42587	3.0%
7	43070	3.0%
8	42887	3.0%
9	44427	3.1%
10	44645	3.1%

Value	Count	Frequency (%)
31	21724	1.5%
30	39930	2.8%
29	158226	11.0%
28	41733	2.9%
27	40780	2.8%
26	42594	3.0%
25	46571	3.2%
24	44380	3.1%
23	44504	3.1%
22	39827	2.8%

day_of_week_first_booking
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5779199

Minimum	0
Maximum	6
Zeros	317201
Zeros (%)	22.1%
Negative	0
Negative (%)	0.0%
Memory size	11.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.0274874
Coefficient of variation (CV)	0.78648192
Kurtosis	-1.2095423
Mean	2.5779199
Median Absolute Deviation (MAD)	2
Skewness	0.2412361
Sum	3706327
Variance	4.1107051
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	317201	22.1%
1	212607	14.8%
2	206274	14.3%
3	204736	14.2%
4	177391	12.3%
6	159845	11.1%
5	159666	11.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	317201	22.1%
1	212607	14.8%
2	206274	14.3%
3	204736	14.2%
4	177391	12.3%
5	159666	11.1%
6	159845	11.1%

Value	Count	Frequency (%)
6	159845	11.1%
5	159666	11.1%
4	177391	12.3%
3	204736	14.2%
2	206274	14.3%
1	212607	14.8%
0	317201	22.1%

week_of_year_first_booking
Real number (ℝ)

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.719971

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.0 MiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	15
median	25
Q3	33
95-th percentile	47
Maximum	53
Range	52
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	12.585084
Coefficient of variation (CV)	0.50910593
Kurtosis	-0.65891785
Mean	24.719971
Median Absolute Deviation (MAD)	9
Skewness	0.19552374
Sum	35540396
Variance	158.38433
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27	150045	10.4%
24	42765	3.0%
21	42283	2.9%
26	41318	2.9%
23	41119	2.9%
19	40926	2.8%
25	40717	2.8%
22	40482	2.8%
20	39530	2.7%
18	35743	2.5%
Other values (43)	922792	64.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	13456	0.9%
2	15685	1.1%
3	21093	1.5%
4	20161	1.4%
5	20696	1.4%
6	22455	1.6%
7	24841	1.7%
8	27228	1.9%
9	26103	1.8%
10	27604	1.9%

Value	Count	Frequency (%)
53	3	< 0.1%
52	12753	0.9%
51	13457	0.9%
50	15296	1.1%
49	14768	1.0%
48	14710	1.0%
47	14471	1.0%
46	17658	1.2%
45	17802	1.2%
44	17461	1.2%

year_account_created
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.0 MiB

2013	554386
2014	475706
2012	292437
2011	98098
2010	17093

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	5750880
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2010
2nd row	2011
3rd row	2010
4th row	2011
5th row	2010

Common Values

Value	Count	Frequency (%)
2013	554386	38.6%
2014	475706	33.1%
2012	292437	20.3%
2011	98098	6.8%
2010	17093	1.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2013	554386	38.6%
2014	475706	33.1%
2012	292437	20.3%
2011	98098	6.8%
2010	17093	1.2%

Most occurring characters

Value	Count	Frequency (%)
2	1730157	30.1%
1	1535818	26.7%
0	1454813	25.3%
3	554386	9.6%
4	475706	8.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5750880	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	1730157	30.1%
1	1535818	26.7%
0	1454813	25.3%
3	554386	9.6%
4	475706	8.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	5750880	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	1730157	30.1%
1	1535818	26.7%
0	1454813	25.3%
3	554386	9.6%
4	475706	8.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5750880	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	1730157	30.1%
1	1535818	26.7%
0	1454813	25.3%
3	554386	9.6%
4	475706	8.3%

month_account_created
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.9491876

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	6
Q3	8
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.1124201
Coefficient of variation (CV)	0.52316724
Kurtosis	-0.86267944
Mean	5.9491876
Median Absolute Deviation (MAD)	2
Skewness	0.28326515
Sum	8553266
Variance	9.6871586
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	198680	13.8%
6	191436	13.3%
4	153215	10.7%
3	138003	9.6%
2	110020	7.7%
8	107499	7.5%
9	104944	7.3%
1	104184	7.2%
7	90808	6.3%
11	82589	5.7%
Other values (2)	156342	10.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	104184	7.2%
2	110020	7.7%
3	138003	9.6%
4	153215	10.7%
5	198680	13.8%
6	191436	13.3%
7	90808	6.3%
8	107499	7.5%
9	104944	7.3%
10	82285	5.7%

Value	Count	Frequency (%)
12	74057	5.2%
11	82589	5.7%
10	82285	5.7%
9	104944	7.3%
8	107499	7.5%
7	90808	6.3%
6	191436	13.3%
5	198680	13.8%
4	153215	10.7%
3	138003	9.6%

day_account_created
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.853177

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.0 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7532198
Coefficient of variation (CV)	0.55214296
Kurtosis	-1.197346
Mean	15.853177
Median Absolute Deviation (MAD)	8
Skewness	-0.001484195
Sum	22792429
Variance	76.618857
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
28	52491	3.7%
3	52066	3.6%
13	50778	3.5%
17	50477	3.5%
24	50055	3.5%
16	49710	3.5%
5	49693	3.5%
10	49084	3.4%
21	48398	3.4%
7	48379	3.4%
Other values (21)	936589	65.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	39368	2.7%
2	43502	3.0%
3	52066	3.6%
4	43942	3.1%
5	49693	3.5%
6	46134	3.2%
7	48379	3.4%
8	48162	3.3%
9	47297	3.3%
10	49084	3.4%

Value	Count	Frequency (%)
31	24636	1.7%
30	47959	3.3%
29	41590	2.9%
28	52491	3.7%
27	45656	3.2%
26	46763	3.3%
25	47541	3.3%
24	50055	3.5%
23	47893	3.3%
22	47367	3.3%

week_of_year_account_created
Real number (ℝ)

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.096319

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.0 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	14
median	23
Q3	34
95-th percentile	48
Maximum	53
Range	52
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	13.480468
Coefficient of variation (CV)	0.55944097
Kurtosis	-0.85296078
Mean	24.096319
Median Absolute Deviation (MAD)	10
Skewness	0.28736465
Sum	34643760
Variance	181.72302
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19	47848	3.3%
26	47059	3.3%
23	46898	3.3%
21	44767	3.1%
22	43375	3.0%
20	43128	3.0%
25	43058	3.0%
24	42370	2.9%
18	42119	2.9%
17	37765	2.6%
Other values (43)	999333	69.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	20435	1.4%
2	18100	1.3%
3	25373	1.8%
4	27393	1.9%
5	24749	1.7%
6	26162	1.8%
7	26454	1.8%
8	29975	2.1%
9	31071	2.2%
10	29844	2.1%

Value	Count	Frequency (%)
53	8	< 0.1%
52	16147	1.1%
51	15921	1.1%
50	16973	1.2%
49	17975	1.3%
48	17407	1.2%
47	19210	1.3%
46	20437	1.4%
45	19288	1.3%
44	18228	1.3%

gender
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.0 MiB

FEMALE	506800
-unknown-	474989
MALE	452413
OTHER	3518

Length

Max length	9
Median length	6
Mean length	6.3593349
Min length	4

Characters and Unicode

Total characters	9142943
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	-unknown-
2nd row	MALE
3rd row	FEMALE
4th row	FEMALE
5th row	-unknown-

Common Values

Value	Count	Frequency (%)
FEMALE	506800	35.3%
-unknown-	474989	33.0%
MALE	452413	31.5%
OTHER	3518	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
female	506800	35.3%
unknown	474989	33.0%
male	452413	31.5%
other	3518	0.2%

Most occurring characters

Value	Count	Frequency (%)
E	1469531	16.1%
n	1424967	15.6%
M	959213	10.5%
A	959213	10.5%
L	959213	10.5%
-	949978	10.4%
F	506800	5.5%
u	474989	5.2%
k	474989	5.2%
o	474989	5.2%
Other values (5)	489061	5.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4868042	53.2%
Lowercase Letter	3324923	36.4%
Dash Punctuation	949978	10.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	1469531	30.2%
M	959213	19.7%
A	959213	19.7%
L	959213	19.7%
F	506800	10.4%
O	3518	0.1%
T	3518	0.1%
H	3518	0.1%
R	3518	0.1%

Lowercase Letter

Value	Count	Frequency (%)
n	1424967	42.9%
u	474989	14.3%
k	474989	14.3%
o	474989	14.3%
w	474989	14.3%

Dash Punctuation

Value	Count	Frequency (%)
-	949978	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8192965	89.6%
Common	949978	10.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	1469531	17.9%
n	1424967	17.4%
M	959213	11.7%
A	959213	11.7%
L	959213	11.7%
F	506800	6.2%
u	474989	5.8%
k	474989	5.8%
o	474989	5.8%
w	474989	5.8%
Other values (4)	14072	0.2%

Common

Value	Count	Frequency (%)
-	949978	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9142943	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	1469531	16.1%
n	1424967	15.6%
M	959213	10.5%
A	959213	10.5%
L	959213	10.5%
-	949978	10.4%
F	506800	5.5%
u	474989	5.2%
k	474989	5.2%
o	474989	5.2%
Other values (5)	489061	5.3%

signup_method
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.0 MiB

basic	1047240
facebook	388720
google	1760

Length

Max length	8
Median length	5
Mean length	5.8123418
Min length	5

Characters and Unicode

Total characters	8356520
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	facebook
2nd row	facebook
3rd row	basic
4th row	facebook
5th row	basic

Common Values

Value	Count	Frequency (%)
basic	1047240	72.8%
facebook	388720	27.0%
google	1760	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
basic	1047240	72.8%
facebook	388720	27.0%
google	1760	0.1%

Most occurring characters

Value	Count	Frequency (%)
b	1435960	17.2%
a	1435960	17.2%
c	1435960	17.2%
s	1047240	12.5%
i	1047240	12.5%
o	780960	9.3%
e	390480	4.7%
f	388720	4.7%
k	388720	4.7%
g	3520	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8356520	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
b	1435960	17.2%
a	1435960	17.2%
c	1435960	17.2%
s	1047240	12.5%
i	1047240	12.5%
o	780960	9.3%
e	390480	4.7%
f	388720	4.7%
k	388720	4.7%
g	3520	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8356520	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
b	1435960	17.2%
a	1435960	17.2%
c	1435960	17.2%
s	1047240	12.5%
i	1047240	12.5%
o	780960	9.3%
e	390480	4.7%
f	388720	4.7%
k	388720	4.7%
g	3520	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8356520	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
b	1435960	17.2%
a	1435960	17.2%
c	1435960	17.2%
s	1047240	12.5%
i	1047240	12.5%
o	780960	9.3%
e	390480	4.7%
f	388720	4.7%
k	388720	4.7%
g	3520	< 0.1%

language
Categorical

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.0 MiB

en	1399438
fr	8519
de	6563
es	5623
zh	4567
Other values (20)	13010

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	2875440
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	en
2nd row	en
3rd row	en
4th row	en
5th row	en

Common Values

Value	Count	Frequency (%)
en	1399438	97.3%
fr	8519	0.6%
de	6563	0.5%
es	5623	0.4%
zh	4567	0.3%
ko	2913	0.2%
it	2622	0.2%
ru	1619	0.1%
pt	1205	0.1%
nl	1183	0.1%
Other values (15)	3468	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
en	1399438	97.3%
fr	8519	0.6%
de	6563	0.5%
es	5623	0.4%
zh	4567	0.3%
ko	2913	0.2%
it	2622	0.2%
ru	1619	0.1%
pt	1205	0.1%
nl	1183	0.1%
Other values (15)	3468	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	1411793	49.1%
n	1400796	48.7%
r	10329	0.4%
f	8570	0.3%
d	6843	0.2%
s	6404	0.2%
h	4634	0.2%
z	4567	0.2%
t	4053	0.1%
o	3088	0.1%
Other values (9)	14363	0.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2875440	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1411793	49.1%
n	1400796	48.7%
r	10329	0.4%
f	8570	0.3%
d	6843	0.2%
s	6404	0.2%
h	4634	0.2%
z	4567	0.2%
t	4053	0.1%
o	3088	0.1%
Other values (9)	14363	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2875440	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1411793	49.1%
n	1400796	48.7%
r	10329	0.4%
f	8570	0.3%
d	6843	0.2%
s	6404	0.2%
h	4634	0.2%
z	4567	0.2%
t	4053	0.1%
o	3088	0.1%
Other values (9)	14363	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2875440	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1411793	49.1%
n	1400796	48.7%
r	10329	0.4%
f	8570	0.3%
d	6843	0.2%
s	6404	0.2%
h	4634	0.2%
z	4567	0.2%
t	4053	0.1%
o	3088	0.1%
Other values (9)	14363	0.5%

affiliate_channel
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.0 MiB

direct	956628
sem-brand	191362
sem-non-brand	132713
seo	60680
other	40030
Other values (3)	56307

Length

Max length	13
Median length	6
Mean length	6.8517806
Min length	3

Characters and Unicode

Total characters	9850942
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	direct
2nd row	seo
3rd row	direct
4th row	direct
5th row	direct

Common Values

Value	Count	Frequency (%)
direct	956628	66.5%
sem-brand	191362	13.3%
sem-non-brand	132713	9.2%
seo	60680	4.2%
other	40030	2.8%
api	35501	2.5%
content	13478	0.9%
remarketing	7328	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
direct	956628	66.5%
sem-brand	191362	13.3%
sem-non-brand	132713	9.2%
seo	60680	4.2%
other	40030	2.8%
api	35501	2.5%
content	13478	0.9%
remarketing	7328	0.5%

Most occurring characters

Value	Count	Frequency (%)
e	1409547	14.3%
r	1335389	13.6%
d	1280703	13.0%
t	1030942	10.5%
i	999457	10.1%
c	970106	9.8%
n	623785	6.3%
-	456788	4.6%
s	384755	3.9%
a	366904	3.7%
Other values (7)	992566	10.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9394154	95.4%
Dash Punctuation	456788	4.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1409547	15.0%
r	1335389	14.2%
d	1280703	13.6%
t	1030942	11.0%
i	999457	10.6%
c	970106	10.3%
n	623785	6.6%
s	384755	4.1%
a	366904	3.9%
m	331403	3.5%
Other values (6)	661163	7.0%

Dash Punctuation

Value	Count	Frequency (%)
-	456788	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9394154	95.4%
Common	456788	4.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1409547	15.0%
r	1335389	14.2%
d	1280703	13.6%
t	1030942	11.0%
i	999457	10.6%
c	970106	10.3%
n	623785	6.6%
s	384755	4.1%
a	366904	3.9%
m	331403	3.5%
Other values (6)	661163	7.0%

Common

Value	Count	Frequency (%)
-	456788	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9850942	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1409547	14.3%
r	1335389	13.6%
d	1280703	13.0%
t	1030942	10.5%
i	999457	10.1%
c	970106	9.8%
n	623785	6.3%
-	456788	4.6%
s	384755	3.9%
a	366904	3.7%
Other values (7)	992566	10.1%

first_affiliate_tracked
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.0 MiB

untracked	782833
linked	313357
omg	297852
tracked-other	29534
product	13330
Other values (2)	814

Length

Max length	13
Median length	9
Mean length	7.1667453
Min length	3

Characters and Unicode

Total characters	10303773
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	untracked
2nd row	untracked
3rd row	untracked
4th row	untracked
5th row	untracked

Common Values

Value	Count	Frequency (%)
untracked	782833	54.4%
linked	313357	21.8%
omg	297852	20.7%
tracked-other	29534	2.1%
product	13330	0.9%
marketing	492	< 0.1%
local ops	322	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
untracked	782833	54.4%
linked	313357	21.8%
omg	297852	20.7%
tracked-other	29534	2.1%
product	13330	0.9%
marketing	492	< 0.1%
local	322	< 0.1%
ops	322	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	1155750	11.2%
d	1139054	11.1%
k	1126216	10.9%
n	1096682	10.6%
t	855723	8.3%
r	855723	8.3%
c	826019	8.0%
a	813181	7.9%
u	796163	7.7%
o	341360	3.3%
Other values (9)	1297902	12.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	10273917	99.7%
Dash Punctuation	29534	0.3%
Space Separator	322	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1155750	11.2%
d	1139054	11.1%
k	1126216	11.0%
n	1096682	10.7%
t	855723	8.3%
r	855723	8.3%
c	826019	8.0%
a	813181	7.9%
u	796163	7.7%
o	341360	3.3%
Other values (7)	1268046	12.3%

Dash Punctuation

Value	Count	Frequency (%)
-	29534	100.0%

Space Separator

Value	Count	Frequency (%)
	322	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10273917	99.7%
Common	29856	0.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1155750	11.2%
d	1139054	11.1%
k	1126216	11.0%
n	1096682	10.7%
t	855723	8.3%
r	855723	8.3%
c	826019	8.0%
a	813181	7.9%
u	796163	7.7%
o	341360	3.3%
Other values (7)	1268046	12.3%

Common

Value	Count	Frequency (%)
-	29534	98.9%
	322	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10303773	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1155750	11.2%
d	1139054	11.1%
k	1126216	10.9%
n	1096682	10.6%
t	855723	8.3%
r	855723	8.3%
c	826019	8.0%
a	813181	7.9%
u	796163	7.7%
o	341360	3.3%
Other values (9)	1297902	12.6%

country_destination
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	11.0 MiB

NDF	119810
US	119810
other	119810
CA	119810
FR	119810
Other values (7)	838670

Length

Max length	5
Median length	2
Mean length	2.3333333
Min length	2

Characters and Unicode

Total characters	3354680
Distinct characters	20
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NDF
2nd row	NDF
3rd row	US
4th row	other
5th row	US

Common Values

Value	Count	Frequency (%)
NDF	119810	8.3%
US	119810	8.3%
other	119810	8.3%
CA	119810	8.3%
FR	119810	8.3%
ES	119810	8.3%
GB	119810	8.3%
IT	119810	8.3%
PT	119810	8.3%
NL	119810	8.3%
Other values (2)	239620	16.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ndf	119810	8.3%
us	119810	8.3%
other	119810	8.3%
ca	119810	8.3%
fr	119810	8.3%
es	119810	8.3%
gb	119810	8.3%
it	119810	8.3%
pt	119810	8.3%
nl	119810	8.3%
Other values (2)	239620	16.7%

Most occurring characters

Value	Count	Frequency (%)
N	239620	7.1%
E	239620	7.1%
F	239620	7.1%
U	239620	7.1%
S	239620	7.1%
T	239620	7.1%
D	239620	7.1%
A	239620	7.1%
P	119810	3.6%
I	119810	3.6%
Other values (10)	1198100	35.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2755630	82.1%
Lowercase Letter	599050	17.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	239620	8.7%
E	239620	8.7%
F	239620	8.7%
U	239620	8.7%
S	239620	8.7%
T	239620	8.7%
D	239620	8.7%
A	239620	8.7%
P	119810	4.3%
I	119810	4.3%
Other values (5)	599050	21.7%

Lowercase Letter

Value	Count	Frequency (%)
r	119810	20.0%
e	119810	20.0%
h	119810	20.0%
t	119810	20.0%
o	119810	20.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3354680	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	239620	7.1%
E	239620	7.1%
F	239620	7.1%
U	239620	7.1%
S	239620	7.1%
T	239620	7.1%
D	239620	7.1%
A	239620	7.1%
P	119810	3.6%
I	119810	3.6%
Other values (10)	1198100	35.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3354680	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	239620	7.1%
E	239620	7.1%
F	239620	7.1%
U	239620	7.1%
S	239620	7.1%
T	239620	7.1%
D	239620	7.1%
A	239620	7.1%
P	119810	3.6%
I	119810	3.6%
Other values (10)	1198100	35.7%

Auto

Heatmap
Table

	age	days_from_first_active_until_account_created	year_first_active	month_first_active	day_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	month_account_created	day_account_created	week_of_year_account_created	year_account_created	gender	signup_method	language	affiliate_channel	first_affiliate_tracked	country_destination
age	1.000	0.007	-0.053	-0.011	-0.002	-0.010	-0.033	-0.016	0.018	0.010	-0.010	-0.010	-0.001	-0.009	0.057	0.253	0.175	0.029	0.070	0.076	0.062
days_from_first_active_until_account_created	0.007	1.000	-0.039	0.009	0.007	0.009	-0.017	0.012	-0.006	-0.004	0.010	0.024	0.012	0.025	0.016	0.019	0.015	0.000	0.023	0.007	0.018
year_first_active	-0.053	-0.039	1.000	-0.439	0.005	-0.427	0.813	-0.295	0.042	-0.023	-0.283	-0.440	0.005	-0.427	0.998	0.089	0.076	0.028	0.113	0.063	0.057
month_first_active	-0.011	0.009	-0.439	1.000	-0.020	0.980	-0.267	0.661	-0.005	-0.007	0.650	0.999	-0.019	0.979	0.277	0.047	0.043	0.033	0.060	0.044	0.053
day_first_active	-0.002	0.007	0.005	-0.020	1.000	0.057	0.016	-0.003	0.345	0.011	0.026	-0.019	0.999	0.058	0.035	0.029	0.029	0.034	0.021	0.032	0.030
week_of_year_first_active	-0.010	0.009	-0.427	0.980	0.057	1.000	-0.263	0.662	0.027	-0.010	0.658	0.979	0.058	0.999	0.268	0.048	0.051	0.034	0.058	0.049	0.055
year_first_booking	-0.033	-0.017	0.813	-0.267	0.016	-0.263	1.000	-0.309	0.215	-0.205	-0.264	-0.267	0.016	-0.263	0.860	0.097	0.069	0.033	0.107	0.059	0.411
month_first_booking	-0.016	0.012	-0.295	0.661	-0.003	0.662	-0.309	1.000	-0.012	-0.025	0.980	0.661	-0.003	0.662	0.186	0.068	0.037	0.033	0.045	0.042	0.209
day_first_booking	0.018	-0.006	0.042	-0.005	0.345	0.027	0.215	-0.012	1.000	-0.164	0.085	-0.006	0.345	0.027	0.038	0.063	0.039	0.038	0.029	0.036	0.238
day_of_week_first_booking	0.010	-0.004	-0.023	-0.007	0.011	-0.010	-0.205	-0.025	-0.164	1.000	-0.062	-0.007	0.011	-0.010	0.034	0.049	0.031	0.036	0.027	0.029	0.234
week_of_year_first_booking	-0.010	0.010	-0.283	0.650	0.026	0.658	-0.264	0.980	0.085	-0.062	1.000	0.650	0.026	0.658	0.183	0.063	0.039	0.038	0.042	0.046	0.189
month_account_created	-0.010	0.024	-0.440	0.999	-0.019	0.979	-0.267	0.661	-0.006	-0.007	0.650	1.000	-0.019	0.980	0.278	0.047	0.044	0.033	0.060	0.044	0.053
day_account_created	-0.001	0.012	0.005	-0.019	0.999	0.058	0.016	-0.003	0.345	0.011	0.026	-0.019	1.000	0.058	0.035	0.030	0.030	0.034	0.021	0.032	0.030
week_of_year_account_created	-0.009	0.025	-0.427	0.979	0.058	0.999	-0.263	0.662	0.027	-0.010	0.658	0.980	0.058	1.000	0.268	0.048	0.051	0.034	0.059	0.049	0.055
year_account_created	0.057	0.016	0.998	0.277	0.035	0.268	0.860	0.186	0.038	0.034	0.183	0.278	0.035	0.268	1.000	0.089	0.077	0.031	0.126	0.070	0.063
gender	0.253	0.019	0.089	0.047	0.029	0.048	0.097	0.068	0.063	0.049	0.063	0.047	0.030	0.048	0.089	1.000	0.283	0.037	0.051	0.043	0.095
signup_method	0.175	0.015	0.076	0.043	0.029	0.051	0.069	0.037	0.039	0.031	0.039	0.044	0.030	0.051	0.077	0.283	1.000	0.034	0.108	0.041	0.044
language	0.029	0.000	0.028	0.033	0.034	0.034	0.033	0.033	0.038	0.036	0.038	0.033	0.034	0.034	0.031	0.037	0.034	1.000	0.045	0.093	0.051
affiliate_channel	0.070	0.023	0.113	0.060	0.021	0.058	0.107	0.045	0.029	0.027	0.042	0.060	0.021	0.059	0.126	0.051	0.108	0.045	1.000	0.325	0.050
first_affiliate_tracked	0.076	0.007	0.063	0.044	0.032	0.049	0.059	0.042	0.036	0.029	0.046	0.044	0.032	0.049	0.070	0.043	0.041	0.093	0.325	1.000	0.050
country_destination	0.062	0.018	0.057	0.053	0.030	0.055	0.411	0.209	0.238	0.234	0.189	0.053	0.030	0.055	0.063	0.095	0.044	0.051	0.050	0.050	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	age	days_from_first_active_until_account_created	year_first_active	month_first_active	day_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	week_of_year_account_created	gender	signup_method	language	affiliate_channel	first_affiliate_tracked	country_destination
0	37	466	2009	3	19	12	2015	6	29	0	27	2010	6	28	26	-unknown-	facebook	en	direct	untracked	NDF
1	38	732	2009	5	23	21	2015	6	29	0	27	2011	5	25	21	MALE	facebook	en	seo	untracked	NDF
2	56	476	2009	6	9	24	2010	8	2	0	31	2010	9	28	39	FEMALE	basic	en	direct	untracked	US
3	42	765	2009	10	31	44	2012	9	8	5	36	2011	12	5	49	FEMALE	facebook	en	direct	untracked	other
4	41	280	2009	12	8	50	2010	2	18	3	7	2010	9	14	37	-unknown-	basic	en	direct	untracked	US
5	37	0	2010	1	1	53	2010	1	2	5	53	2010	1	1	53	-unknown-	basic	en	other	omg	US
6	46	0	2010	1	2	53	2010	1	5	1	1	2010	1	2	53	FEMALE	basic	en	other	untracked	US
7	47	0	2010	1	3	53	2010	1	13	2	2	2010	1	3	53	FEMALE	basic	en	direct	omg	US
8	50	0	2010	1	4	1	2010	7	29	3	30	2010	1	4	1	FEMALE	basic	en	other	untracked	US
9	46	0	2010	1	4	1	2010	1	4	0	1	2010	1	4	1	-unknown-	basic	en	other	omg	US

	age	year_first_active	month_first_active	day_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	week_of_year_account_created	gender	signup_method	language	affiliate_channel	first_affiliate_tracked	country_destination
1437710	37	2014	4	17	16	2014	4	26	5	17	2014	4	17	16	FEMALE	basic	en	direct	untracked	other
1437711	64	2012	12	1	48	2012	12	6	3	49	2012	12	1	48	MALE	basic	en	direct	untracked	other
1437712	37	2012	12	6	49	2012	12	7	4	49	2012	12	6	49	-unknown-	basic	en	direct	untracked	other
1437713	71	2013	3	22	12	2013	4	8	0	15	2013	3	22	12	FEMALE	basic	en	direct	omg	other
1437714	105	2013	3	10	10	2013	3	11	0	11	2013	3	10	10	-unknown-	basic	en	direct	untracked	other
1437715	37	2014	6	7	23	2014	6	7	5	23	2014	6	7	23	-unknown-	basic	en	direct	untracked	other
1437716	37	2013	3	4	10	2013	3	18	0	12	2013	3	4	10	-unknown-	basic	en	sem-non-brand	linked	other
1437717	31	2013	12	29	52	2014	11	1	5	44	2013	12	29	52	MALE	facebook	en	direct	untracked	other
1437718	37	2012	7	25	30	2012	7	26	3	30	2012	7	25	30	MALE	basic	en	sem-non-brand	linked	other
1437719	61	2014	1	12	2	2014	7	8	1	28	2014	1	12	2	MALE	basic	en	seo	linked	other

Most frequently occurring

	age	year_first_active	month_first_active	day_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	week_of_year_account_created	gender	signup_method	language	affiliate_channel	first_affiliate_tracked	country_destination	# duplicates
52998	37	2014	5	29	22	2014	5	29	3	22	2014	5	29	22	-unknown-	basic	en	direct	untracked	PT	1119
45407	37	2013	10	7	41	2013	10	7	0	41	2013	10	7	41	-unknown-	basic	en	direct	untracked	PT	630
70759	69	2014	5	7	19	2014	5	22	3	21	2014	5	7	19	MALE	basic	en	sem-brand	omg	PT	621
31959	36	2013	7	13	28	2013	7	13	5	28	2013	7	13	28	-unknown-	basic	en	direct	untracked	PT	606
46840	37	2013	11	30	48	2013	12	3	1	49	2013	11	30	48	-unknown-	basic	en	direct	linked	PT	603
648	19	2014	6	2	23	2014	6	13	4	24	2014	6	2	23	FEMALE	basic	en	direct	omg	PT	602
54219	37	2014	6	28	26	2014	6	28	5	26	2014	6	28	26	-unknown-	basic	en	direct	linked	PT	602
61041	44	2012	9	12	37	2012	9	13	3	37	2012	9	12	37	FEMALE	basic	en	direct	untracked	PT	602
21832	32	2011	12	19	51	2012	4	3	1	14	2011	12	19	51	FEMALE	facebook	en	direct	untracked	PT	601
16669	30	2012	9	30	39	2013	2	24	6	8	2012	9	30	39	FEMALE	basic	en	direct	product	PT	600

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Dash Punctuation

Space Separator